Tabela PerfServiceAgreement

Definicja tabeli PerfServiceAgreement

Name

PerfServiceAgreement

Code

PerfServiceAgreement

Comment

 


Lista kolumn tabeli PerfServiceAgreement

Name

Code

PerfServiceID

PerfServiceID

AgreementDate

AgreementDate

Comments

Comments

AgrementAccepted

AgrementAccepted

AgreementPerson

AgreementPerson

AgreementRecipientId

AgreementRecipientId


Kolumna PerfServiceID tabeli PerfServiceAgreement

Definicja kolumny PerfServiceID tabeli PerfServiceAgreement

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

jest kluczem glównym i linkiem do tabeli PerfService.PerfServiceID


Kolumna AgreementDate tabeli PerfServiceAgreement

Definicja kolumny AgreementDate tabeli PerfServiceAgreement

Name

AgreementDate

Code

AgreementDate

Data Type

DATE

Mandatory

No

Comment

data uzyskania zgody


Kolumna Comments tabeli PerfServiceAgreement

Definicja kolumny Comments tabeli PerfServiceAgreement

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna AgrementAccepted tabeli PerfServiceAgreement

Definicja kolumny AgrementAccepted tabeli PerfServiceAgreement

Name

AgrementAccepted

Code

AgrementAccepted

Data Type

NUMBER(5)

Mandatory

No

Comment

flaga okreslajaca czy zgoda jest czy nie (1-jest zgoda, 0 brak zgody)


Kolumna AgreementPerson tabeli PerfServiceAgreement

Definicja kolumny AgreementPerson tabeli PerfServiceAgreement

Name

AgreementPerson

Code

AgreementPerson

Data Type

VARCHAR2(255)

Mandatory

No

Comment

osoba, od której uzyskalismy zgode na badanie


Kolumna AgreementRecipientId tabeli PerfServiceAgreement

Definicja kolumny AgreementRecipientId tabeli PerfServiceAgreement

Name

AgreementRecipientId

Code

AgreementRecipientId

Data Type

NUMBER(10)

Mandatory

No

Comment

osoba, która przyjmuje zgloszenie o tym, ze uzyskano zgode (domyslnie zalogowany uzytkownik)


Lista kluczy tabeli PerfServiceAgreement

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PerfServiceAgreement

Definicja klucza Identifier_1 tabeli PerfServiceAgreement

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment